Some Spreadsheet Poka-Yoke
نویسندگان
چکیده
Whilst not all spreadsheet defects are structural in nature, poor layout choices can compromise spreadsheet quality. These defects may be avoided at the development stage by some simple mistake prevention and detection devices. Poka-Yoke (Japanese for Mistake Proofing), which owes its genesis to the Toyota Production System (the standard for manufacturing excellence throughout the world) offers some principles that may be applied to reducing spreadsheet defects. In this paper we examine spreadsheet structure and how it can lead to defects and illustrate some basic spreadsheet Poka-Yokes to reduce them. These include guidelines on how to arrange areas of cells so that whole rows and columns can be inserted anywhere without causing errors, and rules for when to use relative and absolute references with respect to what type of area is being referred to.
منابع مشابه
Poka Yoke system based on image analysis and object recognition
Poka Yoke is a method of quality management which is related to prevent faults from arising during production processes. It deals with “fail-safing” or “mistake-proofing”. The Poka-yoke concept was generated and developed by Shigeo Shingo for the Toyota Production System. Poka Yoke is used in many fields, especially in monitoring production processes. In many cases, identifying faults in a prod...
متن کاملUsing Poka-Yoke Techniques for Early Defect Detection
Poka-yoke is a quality assurance technique developed by Japanese manufacturing engineer Shigeo Shingo. The aim of poka-yoke is to eliminate defects in a product by preventing or correcting mistakes as early as possible. Poka-yoke has been used most frequently in manufacturing environments. Hewlett Packard currently develops its Common Desktop Environment software to run in twelve locales or lan...
متن کاملPreventive Methods in Logistics Poka-yoke and Failure Mode and Effect Analysis (fmea)
Preventive methods are seldom used in logistics, although there is increasing awareness of their potential. This paper presents two examples of preventive methods currently in use, Poka-Yoke and FMEA (Failure Mode and Effect Analysis). The implementation of Poka-Yoke, the mistake proofing methodology, has been shown to drastically reduce the enormous warranty costs, including logistics costs, w...
متن کاملImplementation of poka-yoke in Indian manufacturing industry by: enablers, barriers and questionnaire based survey
__________________________________________________________________________________________________________ In today global economy, the survival of companies depends on their ability to rapidly innovate and improve. As a result, an increasing search is on for the methods and processes that drive improvements in quality, costs and productivity. In the manufacturing industry PokaYoke method has b...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- CoRR
دوره abs/0908.0930 شماره
صفحات -
تاریخ انتشار 2009